var mysql = require('mysql');
var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: 'localhost',
    database: 'cl'
});


module.exports = (sql) => {
    return new Promise(next =>{
        connection.connect();
        connection.query(sql, function (error, results, fields) {
            if (error) throw error;
            // console.log('The solution is: ', results[0].solution);
            next(results)
        });
    
        // connection.end();
    
    })
    
}